
CREATE TABLE Base_SysLoginlog
(
	SYS_LOGINLOG_ID VARCHAR2(50),
	SYS_LOGINLOG_IP VARCHAR2(50),
	SYS_LOGINLOG_TIME DATE DEFAULT(SYSDATE),
	User_Account VARCHAR2(50),
	SYS_LOGINLOG_STATUS INT,
	OWNER_address VARCHAR2(200)
);

/*

CREATE TABLE [dbo].[Base_SysLoginlog](
	[SYS_LOGINLOG_ID] [dbo].[Name(50)] NULL,
	[SYS_LOGINLOG_IP] [dbo].[Name(50)] NULL,
	[SYS_LOGINLOG_TIME] [Date] NULL,
	[User_Account] [dbo].[Name(50)] NULL,
	[SYS_LOGINLOG_STATUS] [dbo].[ID] NULL,
	[OWNER_address] [dbo].[Name(200)] NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'登录日志主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_SysLoginlog', @level2type=N'COLUMN',@level2name=N'SYS_LOGINLOG_ID'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'登录IP' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_SysLoginlog', @level2type=N'COLUMN',@level2name=N'SYS_LOGINLOG_IP'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'登录时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_SysLoginlog', @level2type=N'COLUMN',@level2name=N'SYS_LOGINLOG_TIME'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'登录账户' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_SysLoginlog', @level2type=N'COLUMN',@level2name=N'User_Account'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'登录状态' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_SysLoginlog', @level2type=N'COLUMN',@level2name=N'SYS_LOGINLOG_STATUS'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'IP所在地址' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_SysLoginlog', @level2type=N'COLUMN',@level2name=N'OWNER_address'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'登录日志' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_SysLoginlog'
GO

ALTER TABLE [dbo].[Base_SysLoginlog] ADD  CONSTRAINT [DF_Base_SysLoginlog_SYS_LOGINLOG_TIME]  DEFAULT (getdate()) FOR [SYS_LOGINLOG_TIME]
GO

*/